Invoking calls to OS from DXL script

SystemAdmin - Wed Sep 16 02:38:33 EDT 2009
Probably you could bypass that problem by adding quotation marks around your strFile, i.e.

string outCmd = "cmd /C start \"" strFile "\""

...well this did not work for me...

But what did work without any other changes was to replace your

string outCmd = "cmd /C start " strFile ""
system (outCmd)

with just

activateURL(strFile)

SystemAdmin - Wed Sep 16 09:46:51 EDT 2009
Excellent, that solution worked perfectly, of course.

Yep, it's right there in DXL Help, though how I would have found it on my own I don't know.

Thanks again.

Bosch - Thu Sep 08 05:03:19 EDT 2011
Hello,

I have a dxl script were it will generate a report in Excel sheet, but i want to generate the ouptut in html format.
Kindly help me out how to output the data into a html.

Attached is the dxl script were it will generate the report in excel.
kindly have a look and let me know how to out put the data in html.

Thank you!

Regards,
Shruthi

OurGuest - Thu Sep 08 07:19:19 EDT 2011
Looks like the easiest would be either modify the dxl to tell excel to save as html or manually save the excel file as html.

Bosch - Fri Sep 09 00:35:20 EDT 2011
Hello,

I don't want to change it manually , i want directly to output the data to HTML
On running the dxl script the out put should be opened in the HTML or save the file as HTML with the output.

I have no clue how they will out put the data to HTML like excel.

May i know what would be the syntax for it.

Thank you!

Regards,
shruthi

Mathias Mamsch - Fri Sep 09 03:27:19 EDT 2011

You really need to stop pulling some old posts which have absolutely nothing to do with your question. Next time please open a new post for a question like this, so other users will be able to find the information. To write a HTML file you need to write to a file directly. There is no builtin HTML functionality which makes this any easier for you. So you need to build a file with HTML syntax manually. This would look something like

<HTML>
<TITLE> Title </TITLE>
<BODY> <TABLE border = 1> 
<TR> <TD> Value 1... </TD> <TD> Value 2... </TD> </TR> 
<TR> <TD> Value 2... </TD> <TD> Value 2... </TD> </TR> 
</TABLE> </BODY>
</HTML>

So you need to replace all the setExcelCell OLE calls in your code by the corresponding "Write to a file" code. If you do not know how to write to a file, look for 'Stream' in the forum and in the DXL help. Hope that helps, Regards, Mathias

Mathias Mamsch, IT-QBase GmbH, Consultant for Requirement Engineering and D00RS